Summarizing data with aggregate functions

Aggregate functions

Use aggregate functions to obtain summary information on all records or on specific groups of records. Aggregate functions are most useful when you do not need the detailed information and you only want to examine totals.

For example, you might need the total number of orders made and the average amount of each order. For this type of query, you apply the Count function to the Order ID field, and the AVG (average) function to the Amount field. The query calculates the summary information and provides the results you need.

To summarize data with an aggregate function
  1. Select the field you want to summarize from the Query Fields area.
  2. Choose an aggregate function to apply to the selected field from the Total drop-down list:


Seagate Software IMG Holdings, Inc.
http://www.seagatesoftware.com
Support services:
http://support.seagatesoftware.com